# -*- coding: utf-8 -*-


import numpy as np
import pandas as pd
import matplotlib as mpl
import matplotlib.pyplot as plt


def rpt01():
    excel_path = r'1.xlsx'
    df0 = pd.read_excel(excel_path, sheet_name=0)
    ax = plt.subplot()
    ax.plot(df0.index, df0.loc[:, 'fund_cumulative_nav'], color='#DA8137')

    # ax.set_title(label='')
    # ax.set_xscale(value='linear')

    ax.set_ylim(bottom=min(df0.loc[:, 'fund_cumulative_nav']), top=max(df0.loc[:, 'fund_cumulative_nav']))
    # ax.yaxis.set_major_formatter(formatter=)
    ax.grid(axis='y')

    plt.show()

    pass


if __name__ == '__main__':

    rpt01()

    pass
